<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="com.example.demo2.DBUtil" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
		 pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8">
		<title>Insert title here</title>
		<link rel="stylesheet" type="text/css" href="css/rest.css"/>
		<style type="text/css">
			body{width: 100%;height: 100%;}
			*{margin: 0;padding: 0;}
				.bjt{background:radial-gradient(#6f4351,#40325b);width: 100%;height: 120px;}
				.huixiang{width: 200px;height: 80px;position: absolute;left: 0px;top: 10px;}
				.ziti{font-size: 25px;font-style: italic;font-family: 宋体;color:#91b5ff ;font-weight: 600;position: absolute;left:180px;top: 44px;}
				li{float: left;font-size: 22px;padding: 10px;margin-left: 60px;color: aqua;}
				.liebiao{position: absolute;left: 300px;top: 35px;}
				.zixuankuang{font-size: 12px;color: gray;width: 210px;height:38px;position: absolute;left: 1100px;top: 38px;border-radius: 50px;}
				.sousuo{width: 40px;height: 38px;position: absolute;left: 1274px;top: 40px;border-radius: 50px;background-color: dimgray;}
				li>a{color: white;}
				.denglu>a{color: white;}
				
				.si{background-color: black;height: 300px;position: relative;top: 1800px;}
				.c1{font-size: 18px;font-weight: 300;color: white;position: absolute;left: 450px;top: 50px;}
				.c1-1{color: red;}
				.c2{font-size: 18px;font-weight: 300;position: absolute;left: 520px;top:80px;color: white;}
				.c3{font-size: 18px;font-weight: 300;color: white;position: absolute;left: 600px;top:120px;}
				.c4{height: 40px;width: 130px;position: absolute;left: 580px;top:180px;}
				.c5{height: 40px;width: 130px;position: absolute;left: 740px;top:180px;}
				.c6{height: 40px;width: 130px;position: absolute;left: 900px;top:180px;}
				
				.k1{width: 120px;height: 50px;background-color: red ;color: white;font-size: 22px;border-radius: 50px;text-align: center;line-height: 50px;margin-left: 1230px;margin-top: -50px;}
				.k2{width: 1100px;height: 1305px;margin-left: 330px;margin-top: 50px;}
				
				.k3{width: 285px;height: 285px;}
				.k3-1{margin-top: 10px;margin-left: 18px;font-weight: 500;font-size: 18px;}
				.k3-2{margin-top: 10px;margin-left: 60px;color: red;font-size: 20px;font-weight: 600;}
				.k3-3{margin-left: 8px;color:gray;font-size: 18px;font-weight: 600;}
				
				.k4{width: 285px;height: 285px;position: absolute;left: 700px;top: 350px;}
				.k4-1{margin-top: 10px;margin-left: 24px;font-weight: 500;font-size: 18px;position: absolute;left: 700px;top: 642px;}
				.k4-2{margin-top: 10px;margin-left: 60px;color: red;font-size: 20px;font-weight: 600;}
				.k4-3{margin-left: 8px;color:gray;font-size: 18px;font-weight: 600;}
				
				.k5{width: 285px;height: 285px;position: absolute;left: 350px;top: -300px;}
				.k5-1{margin-left: -30px;font-weight: 500;font-size: 18px;position: absolute;left: 400px;top: 0px;width: 300px;}
				.k5-2{margin-top: 10px;margin-left: 60px;color: red;font-size: 20px;font-weight: 600;}
				.k5-3{margin-left: 8px;color:gray;font-size: 18px;font-weight: 600;}
				
				.k6{width: 285px;height: 285px;margin-top: 30px;margin-left: -762px;}
				.k6-1{margin-top: 10px;margin-left: -740px;font-weight: 500;font-size: 18px;}
				.k6-2{margin-top: 10px;margin-left: 60px;color: red;font-size: 20px;font-weight: 600;}
				.k6-3{margin-left: 8px;color:gray;font-size: 18px;font-weight: 600;}
				
				.k7{width: 285px;height: 285px;position: absolute;left: -390px;top: 90px;}
				.k7-1{margin-top: -60px;margin-left: 370px;font-weight: 500;font-size: 18px;}
				.k7-2{margin-top: 10px;margin-left: 60px;color: red;font-size: 20px;font-weight: 600;}
				.k7-3{margin-left: 8px;color:gray;font-size: 18px;font-weight: 600;}
				
				.k8{width: 285px;height: 285px;position: absolute;left: -20px;top: 90px;}
				.k8-1{margin-top: -60px;margin-left: 370px;font-weight: 500;font-size: 18px;}
				.k8-2{margin-top: 10px;margin-left: 60px;color: red;font-size: 20px;font-weight: 600;}
				.k8-3{margin-left: 8px;color:gray;font-size: 18px;font-weight: 600;}
				
				.k9{width: 285px;height: 285px;position: absolute;left: -762px;top: 480px;}
				.k9-1{margin-top: 10px;margin-left: 24px;font-weight: 500;font-size: 18px;position: absolute;left: -767px;top: 772px;}
				.k9-2{margin-top: 10px;margin-left: 60px;color: red;font-size: 20px;font-weight: 600;}
				.k9-3{margin-left: 8px;color:gray;font-size: 18px;font-weight: 600;}
				
				.k10{width: 285px;height: 285px;position: absolute;left: 350px;top: -300px;}
				.k10-1{margin-top: 10px;margin-left: 24px;font-weight: 500;font-size: 18px;position: absolute;left: 340px;top: -10px;width: 300px;}
				.k10-2{margin-top: 10px;margin-left: 60px;color: red;font-size: 20px;font-weight: 600;}
				.k10-3{margin-left: 8px;color:gray;font-size: 18px;font-weight: 600;}
				
				.k11{width: 285px;height: 285px;position: absolute;left: 360px;top: -300px;}
				.k11-1{margin-top: 10px;margin-left: 24px;font-weight: 500;font-size: 18px;position: absolute;left: 350px;top: -10px;width: 300px;}
				.k11-2{margin-top: 10px;margin-left: 60px;color: red;font-size: 20px;font-weight: 600;}
				.k11-3{margin-left: 8px;color:gray;font-size: 18px;font-weight: 600;}
				
				
				
				
		</style>
	</head>
	<body>
		<div class="bjt">
			<img src="img/R-C.png" class="huixiang">
			<div class="ziti">悦享汇电影</div>
			<div class="liebiao">
				<ul>
				<li><a href="shouye.jsp">首页</a></li>
				<li><a href="dianying.jsp">电影</a></li>
				<li><a href="yingyuan.jsp">影院</a></li>
				<li><a href="bangdan.jsp">榜单</a></li>
				<li><a href="redian.jsp">热点</a></li>
				<li><a href="shangcheng.jsp">商城</a></li>
			</ul>
			</div>
			<%@include file="sousuo.jsp"%>
			<%@include file="dl.jsp"%>

		</div>
			<div style="display: grid;
				 grid-template-columns: repeat(4, 1fr);
				 grid-row-gap: 5%;
				 margin: 20px auto;
    			 width: 80%;
			">
				<%
					Connection cn = null;
					PreparedStatement ps = null;

					ResultSet rs = null;
					String sql = "";
					cn = DBUtil.getConnection();
					sql = "select * from shangp";
					ps = cn.prepareStatement(sql);
					rs = ps.executeQuery();

					while(rs.next()){
						int id = rs.getInt("id");
						String name = rs.getString("name");
						String img = rs.getString("img");
						String qian = rs.getString("qian");
						String new_qian = rs.getString("new_qian");

				%>
				<div>
					<a href="qianggou.jsp?id=<%=id%>"><img src="<%=img%>" class="k3"></a>
					<div class="k3-1">
						<a href="qianggou.jsp"><%=name%></a>
						<div class="k3-2">￥<%=new_qian%> <span class="k3-3"><del>￥<%=qian%></del> </span>
						</div>
					</div>
				</div>
				<%
					}
				%>
			</div>

		<div class="si">
													<div class="c1">关于悦享汇：<span class="c1-1">关于我们	| 管理团队 | 投资者关系 |</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;友情链接：<span class="c1-1">美团网 | 美团下载 | 欢喜首映 |</span></div>
													<div class="c2">QQ邮箱：2112633811.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;客服电话：152425125</div>
													<div class="c3">悦享汇用户服务协议 |			悦享汇平台交易规则总则 | 			隐私政策 |</div>
													<img src="img/C9.png"class="c4" >
													<img src="img/C8.png"class="c5" >
													<img src="img/C7.png"class="c6" >
												</div>


	</body>
</html>
